﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using NPOI.HSSF.UserModel;
using NPOI.HPSF;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace syc.Store.报表
{
    public partial class 物资收发存统计表 : System.Web.UI.Page
    {
        protected HSSFWorkbook hssfworkbook;
        protected string year;
        protected string month;
        //原料
        //期初库存
        protected double 油管料期初库存;
        protected double 套管料期初库存;
        protected double 套管N80料期初库存;
        protected double 油管接篐料期初库存;
        protected double 套管接篐料期初库存;
        protected double 套管N80接篐料期初库存;
        //本期外购量
        protected double 油管料本期外购量;
        protected double 套管料本期外购量;
        protected double 套管N80料本期外购量;
        protected double 油管接篐料本期外购量;
        protected double 套管接篐料本期外购量;
        protected double 套管N80接篐料本期外购量;

        //本期外购量累计
        protected double 油管料本期外购量累计;
        protected double 套管料本期外购量累计;
        protected double 套管N80料本期外购量累计;
        protected double 油管接篐料本期外购量累计;
        protected double 套管接篐料本期外购量累计;
        protected double 套管N80接篐料本期外购量累计;

        //本期消耗量
        protected double 油管料本期消耗量;
        protected double 套管料本期消耗量;
        protected double 套管N80料本期消耗量;
        protected double 油管接篐料本期消耗量;
        protected double 套管接篐料本期消耗量;
        protected double 套管N80接篐料本期消耗量;

        //本期消耗量累计
        protected double 油管料本期消耗量累计;
        protected double 套管料本期消耗量累计;
        protected double 套管N80料本期消耗量累计;
        protected double 油管接篐料本期消耗量累计;
        protected double 套管接篐料本期消耗量累计;
        protected double 套管N80接篐料本期消耗量累计;

        //期末库存
        protected double 油管料期末库存;
        protected double 套管料期末库存;
        protected double 套管N80料期末库存;
        protected double 油管接篐料期末库存;
        protected double 套管接篐料期末库存;
        protected double 套管N80接篐料期末库存;
        //成品套管接箍J55
        protected double 成品套管接箍期初库存;
        protected double 成品套管接箍本期外购量;
        protected double 成品套管接箍本期消耗量;
        protected double 成品套管接箍期末库存;
        protected double 成品套管接箍本期外购量累计;
        protected double 成品套管接箍本期消耗量累计;

        //成品套管接箍N80
        protected double 成品套管N80接箍期初库存;
        protected double 成品套管N80接箍本期外购量;
        protected double 成品套管N80接箍本期消耗量;
        protected double 成品套管N80接箍期末库存;
        protected double 成品套管N80接箍本期外购量累计;
        protected double 成品套管N80接箍本期消耗量累计;

        //自产接箍
        protected double 自产套管接箍期初库存;
        protected double 自产套管接箍本期外购量;
        protected double 自产套管接箍本期消耗量;
        protected double 自产套管接箍期末库存;
        protected double 自产套管接箍本期外购量累计;
        protected double 自产套管接箍本期消耗量累计;

        protected double 自产油管接箍期初库存;
        protected double 自产油管接箍本期外购量;
        protected double 自产油管接箍本期消耗量;
        protected double 自产油管接箍期末库存;
        protected double 自产油管接箍本期外购量累计;
        protected double 自产油管接箍本期消耗量累计;
        //成品
        protected double 油管上期结存;
        protected double 套管上期结存;
        protected double 套管N80上期结存;   

        protected double 油管本期入库;
        protected double 套管本期入库;
        protected double 套管N80本期入库;

        protected double 油管本期入库累计;
        protected double 套管本期入库累计;
        protected double 套管N80本期入库累计;

        protected double 油管本期发货;
        protected double 套管本期发货;
        protected double 套管N80本期发货;

        protected double 油管本期发货累计;
        protected double 套管本期发货累计;
        protected double 套管N80本期发货累计;

        protected double 油管本期销售;
        protected double 套管本期销售;
        protected double 套管N80本期销售;

        protected double 油管本期结存;
        protected double 套管本期结存;
        protected double 套管N80本期结存;


      
    }
}
